package com.chineseall.rebirth.bridge.dao;

public final class BridgeSqls {

    public static final String GET_AUTHOR = "select id from author where userId=? limit 1";

    public static final String IS_MONTHLY = "select endTime from monthsubscription where  userId = ?  and packageId = 3 and status = 1 order by id desc limit 1";

    public static final String FANS_LEVEL = "select le.title ,le.level,fans.scoreCount as endScore,le.imgUrl from fansscoredetail fans,fanslevel le where fans.scoreCount >= le.startScore and fans.scoreCount < le.endScore and fans.userId=?  and fans.bookId=? limit 1";

}
